/****** Object:  Stored Procedure dbo.asi_NewAccessArea    Script Date: 7/3/2003 4:58:04 PM ******/

CREATE PROCEDURE [dbo].[asi_NewAccessArea]
    @isSharedACLOnly bit,
    @sysEntityKey uniqueidentifier,
    @userKey uniqueidentifier,
    @name varchar(50),
    @description varchar(250),
    @accessAreaKey uniqueidentifier output,
    @accessKeyForArea uniqueidentifier output
AS

DECLARE @now datetime

SET @now = GETDATE()

IF (@accessKeyForArea is null)
BEGIN
    SELECT @accessKeyForArea = NEWID()
END

SELECT @accessAreaKey = NEWID()

-- The ACL that the access area represents (protects):
INSERT INTO AccessMain(AccessKey, AccessScope, CreatedByUserKey, CreatedOn, UpdatedByUserKey, UpdatedOn)
    SELECT @accessKeyForArea, 'Area', @userKey, @now, @userKey, @now

-- The access area:
INSERT INTO AccessArea (AccessAreaKey, [Name], Description, IsSystem, ProtectedAccessKey,
                        UpdatedByUserKey, UpdatedOn, IsSharedACLOnly, CreatedByUserKey, CreatedOn)
    SELECT @accessAreaKey, @name, @description, 1, @accessKeyForArea,
           @userKey, @now, @isSharedACLOnly, @userKey, @now

GO